{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["input1","input2","bedrijfsresultaat "],"not_rendered":{"charts":2,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"input1","index":0,"n_rows":39,"n_cols":16,"rows_kept":39,"hidden":true,"merged":[[13,8,13,9],[15,3,15,4],[22,5,22,6],[24,5,24,6],[29,6,38,6]]}
[]
["Bedrijfsresultaat fritesstudio 2018"]
[]
[null,"omschrijving verkoop","jan","feb","mrt","apr","mei","jun","jul","aug","sep","okt","nov","dec","totaal omzet","Inkoop"]
[null,"frites",{"v":7875,"d":"€ 7,875.00"},{"v":8662.5,"d":"€ 8,662.50"},{"v":7087.5,"d":"€ 7,087.50"},{"v":7875,"d":"€ 7,875.00"},{"v":9450,"d":"€ 9,450.00"},{"v":11812.5,"d":"€ 11,812.50"},{"v":12206.25,"d":"€ 12,206.25"},{"v":12048.75,"d":"€ 12,048.75"},{"v":11418.75,"d":"€ 11,418.75"},{"v":11025,"d":"€ 11,025.00"},{"v":11103.75,"d":"€ 11,103.75"},{"v":12206.25,"d":"€ 12,206.25"},{"$f":"SUM(C5:N5)","v":{"v":122771.25,"d":"€ 122,771.25"}},{"$f":"O5*30%","v":{"v":36831.375,"d":"€ 36,831.38"}}]
[null,"fish & chips",{"v":9187.5,"d":"€ 9,187.50"},{"v":8268.75,"d":"€ 8,268.75"},{"v":9187.5,"d":"€ 9,187.50"},{"v":9003.75,"d":"€ 9,003.75"},{"v":10106.25,"d":"€ 10,106.25"},{"v":11025,"d":"€ 11,025.00"},{"v":12127.5,"d":"€ 12,127.50"},{"v":12311.25,"d":"€ 12,311.25"},{"v":10106.25,"d":"€ 10,106.25"},{"v":9738.75,"d":"€ 9,738.75"},{"v":9555,"d":"€ 9,555.00"},{"v":10473.75,"d":"€ 10,473.75"},{"$f":"SUM(C6:N6)","v":{"v":121091.25,"d":"€ 121,091.25"}},{"$f":"O6*30%","v":{"v":36327.375,"d":"€ 36,327.38"}}]
[null,"friet stoofvlees",{"v":4987.5,"d":"€ 4,987.50"},{"v":5985,"d":"€ 5,985.00"},{"v":4987.5,"d":"€ 4,987.50"},{"v":4788,"d":"€ 4,788.00"},{"v":5187,"d":"€ 5,187.00"},{"v":3990,"d":"€ 3,990.00"},{"v":4189.5,"d":"€ 4,189.50"},{"v":3990,"d":"€ 3,990.00"},{"v":4389,"d":"€ 4,389.00"},{"v":4189.5,"d":"€ 4,189.50"},{"v":4987.5,"d":"€ 4,987.50"},{"v":6384,"d":"€ 6,384.00"},{"$f":"SUM(C7:N7)","v":{"v":58054.5,"d":"€ 58,054.50"}},{"$f":"O7*39%","v":{"v":22641.255,"d":"€ 22,641.26"}}]
[null,"kapsalon",{"v":10017,"d":"€ 10,017.00"},{"v":10851.75,"d":"€ 10,851.75"},{"v":10350.9,"d":"€ 10,350.90"},{"v":10017,"d":"€ 10,017.00"},{"v":11018.7,"d":"€ 11,018.70"},{"v":11185.65,"d":"€ 11,185.65"},{"v":11018.7,"d":"€ 11,018.70"},{"v":10851.75,"d":"€ 10,851.75"},{"v":10017,"d":"€ 10,017.00"},{"v":9015.300000000001,"d":"€ 9,015.30"},{"v":9182.25,"d":"€ 9,182.25"},{"v":9516.15,"d":"€ 9,516.15"},{"v":123042.15000000001,"d":"€ 123,042.15"},{"v":36912.645000000004,"d":"€ 36,912.65"}]
[null,"frisdranken",{"v":6300,"d":"€ 6,300.00"},{"v":6930,"d":"€ 6,930.00"},{"v":5985,"d":"€ 5,985.00"},{"v":6300,"d":"€ 6,300.00"},{"v":5544,"d":"€ 5,544.00"},{"v":7560,"d":"€ 7,560.00"},{"v":7686,"d":"€ 7,686.00"},{"v":7308,"d":"€ 7,308.00"},{"v":6930,"d":"€ 6,930.00"},{"v":6363,"d":"€ 6,363.00"},{"v":5040,"d":"€ 5,040.00"},{"v":4814,"d":"€ 4,814.00"},{"v":76760,"d":"€ 76,760.00"},{"v":23028,"d":"€ 23,028.00"}]
[null,"bier",{"v":2520,"d":"€ 2,520.00"},{"v":2100,"d":"€ 2,100.00"},{"v":1428,"d":"€ 1,428.00"},{"v":1680,"d":"€ 1,680.00"},{"v":3360,"d":"€ 3,360.00"},{"v":8400,"d":"€ 8,400.00"},{"v":9240,"d":"€ 9,240.00"},{"v":9408,"d":"€ 9,408.00"},{"v":8400,"d":"€ 8,400.00"},{"v":8316,"d":"€ 8,316.00"},{"v":7140,"d":"€ 7,140.00"},{"v":6384,"d":"€ 6,384.00"},{"v":68376,"d":"€ 68,376.00"},{"v":20512.8,"d":"€ 20,512.80"}]
[null,"wijn",{"v":2100,"d":"€ 2,100.00"},{"v":1575,"d":"€ 1,575.00"},{"v":1575,"d":"€ 1,575.00"},{"v":2100,"d":"€ 2,100.00"},{"v":2310,"d":"€ 2,310.00"},{"v":5775,"d":"€ 5,775.00"},{"v":5880,"d":"€ 5,880.00"},{"v":6300,"d":"€ 6,300.00"},{"v":5670,"d":"€ 5,670.00"},{"v":5355,"d":"€ 5,355.00"},{"v":4200,"d":"€ 4,200.00"},{"v":5775,"d":"€ 5,775.00"},{"$f":"SUM(C11:N11)","v":{"v":48615,"d":"€ 48,615.00"}},{"v":14584.5,"d":"€ 14,584.50"}]
[null,"Totaal omzet ",{"$nulls":12},{"$f":"SUM(O5:O10)","v":{"v":570095.15,"d":"€ 570,095.15"}}]
[]
[]
[null,"Overige kosten"]
[null,"gas",{"v":7500,"d":"€ 7,500.00"}]
[null,"elektra",{"v":3500,"d":"€ 3,500.00"}]
[null,"huur pand incl. btw",{"v":36000,"d":"€ 36,000.00"}]
[null,"verpakking (disposables)",{"v":50400,"d":"€ 50,400.00"}]
[null,"personeelskosten",{"v":225000,"d":"€ 225,000.00"}]
[]
[]
[]
[]
[{"$nulls":7},"Mireille, hier zit een koppeling met de cel van de som van de inkoop; maar die koppeling mag er van mij wel uit (voorlopig?)"]
[]
[]
[]
[]
[null,"prijslijst","€",{"$nulls":4},"Mireille, de prijslijst wel opnemen in het bestand"]
[null,"frites met saus naar keuze",3.75,21,155,{"$f":"E31*D31*C31","v":{"v":12206.25,"d":"€ 12,206.25"}}]
[null,"fish & chips",8.75,21,57,{"$f":"E32*D32*C32","v":{"v":10473.75,"d":"€ 10,473.75"}}]
[null,"friet stoofvlees",9.5,21,32,{"v":6384,"d":"€ 6,384.00"}]
[null,"kapsalon",7.95,21,57,{"v":9516.15,"d":"€ 9,516.15"}]
[null,"frisdranken",2.5,21,75,{"v":3937.5,"d":"€ 3,937.50"}]
[null,"bier (1/2 liter)",4,21,76,{"v":6384,"d":"€ 6,384.00"},null,null,"gebruik het werkblad bedrijfsresultaat"]
[null,"wijn (flesje 250 ml)",5,21,55,{"v":5775,"d":"€ 5,775.00"}]
[]
[{"$nulls":4},{"$f":"SUM(E31:E38)","v":507}]

{"sheet":"input2","index":1,"n_rows":33,"n_cols":10,"rows_kept":33,"hidden":true,"merged":[[12,8,12,9],[14,3,14,4],[23,6,32,6]]}
["Bedrijfsresultaat fritesstudio 2018"]
[]
[null,"omschrijving verkoop","jan-feb","mrt-apr","mei-jun","jul-aug","sep-okt","nov-dec","totaal omzet","Inkoop"]
[null,"frites",{"v":16537.5,"d":"€ 16,537.50"},{"v":14962.5,"d":"€ 14,962.50"},{"v":21262.5,"d":"€ 21,262.50"},{"v":24255,"d":"€ 24,255.00"},{"v":22443.75,"d":"€ 22,443.75"},{"v":23310,"d":"€ 23,310.00"},{"$f":"SUM(C4:H4)","v":{"v":122771.25,"d":"€ 122,771.25"}},{"$f":"I4*30%","v":{"v":36831.375,"d":"€ 36,831.38"}}]
[null,"fish & chips",{"v":17456.25,"d":"€ 17,456.25"},{"v":18191.25,"d":"€ 18,191.25"},{"v":21131.25,"d":"€ 21,131.25"},{"v":24438.75,"d":"€ 24,438.75"},{"v":19845,"d":"€ 19,845.00"},{"v":20028.75,"d":"€ 20,028.75"},{"v":121091.25,"d":"€ 121,091.25"},{"$f":"I5*30%","v":{"v":36327.375,"d":"€ 36,327.38"}}]
[null,"friet stoofvlees",{"v":10972.5,"d":"€ 10,972.50"},{"v":9775.5,"d":"€ 9,775.50"},{"v":9177,"d":"€ 9,177.00"},{"v":8179.5,"d":"€ 8,179.50"},{"v":8578.5,"d":"€ 8,578.50"},{"v":11371.5,"d":"€ 11,371.50"},{"v":58054.5,"d":"€ 58,054.50"},{"$f":"I6*39%","v":{"v":22641.255,"d":"€ 22,641.26"}}]
[null,"kapsalon",{"v":20868.75,"d":"€ 20,868.75"},{"v":20367.9,"d":"€ 20,367.90"},{"v":22204.35,"d":"€ 22,204.35"},{"v":21870.45,"d":"€ 21,870.45"},{"v":19032.300000000003,"d":"€ 19,032.30"},{"v":18698.4,"d":"€ 18,698.40"},{"v":123042.15,"d":"€ 123,042.15"},{"v":36912.645,"d":"€ 36,912.65"}]
[null,"frisdranken",{"v":13230,"d":"€ 13,230.00"},{"v":12285,"d":"€ 12,285.00"},{"v":13104,"d":"€ 13,104.00"},{"v":14994,"d":"€ 14,994.00"},{"v":13293,"d":"€ 13,293.00"},{"v":9854,"d":"€ 9,854.00"},{"v":76760,"d":"€ 76,760.00"},{"v":23028,"d":"€ 23,028.00"}]
[null,"bier",{"v":4620,"d":"€ 4,620.00"},{"v":3108,"d":"€ 3,108.00"},{"v":11760,"d":"€ 11,760.00"},{"v":18648,"d":"€ 18,648.00"},{"v":16716,"d":"€ 16,716.00"},{"v":13524,"d":"€ 13,524.00"},{"v":68376,"d":"€ 68,376.00"},{"v":20512.8,"d":"€ 20,512.80"}]
[null,"wijn",{"v":3675,"d":"€ 3,675.00"},{"v":3675,"d":"€ 3,675.00"},{"v":8085,"d":"€ 8,085.00"},{"v":12180,"d":"€ 12,180.00"},{"v":11025,"d":"€ 11,025.00"},{"v":9975,"d":"€ 9,975.00"},{"v":48615,"d":"€ 48,615.00"},{"v":14584.5,"d":"€ 14,584.50"}]
[null,"Totaal omzet ",{"$nulls":6},{"$f":"SUM(I4:I10)","v":{"v":618710.15,"d":"€ 618,710.15"}}]
[]
[]
[null,"Overige kosten"]
[null,"gas",{"v":7500,"d":"€ 7,500.00"},{"$nulls":4},"eventu de kolommen inkoop en totaal omzet van plaats wisselen"]
[null,"elektra",{"v":3500,"d":"€ 3,500.00"},{"$nulls":4},"en te overwegen is om bij totaal omzet geen getallen in te vullen"]
[null,"huur pand incl. btw",{"v":36000,"d":"€ 36,000.00"}]
[null,"verpakking (disposables)",{"v":50400,"d":"€ 50,400.00"}]
[null,"personeelskosten",{"v":225000,"d":"€ 225,000.00"}]
[]
[]
[]
[]
[null,"prijslijst","€"]
[null,"frites met saus naar keuze",3.75,21,155,{"$f":"E25*D25*C25","v":{"v":12206.25,"d":"€ 12,206.25"}}]
[null,"fish & chips",8.75,21,57,{"$f":"E26*D26*C26","v":{"v":10473.75,"d":"€ 10,473.75"}}]
[null,"friet stoofvlees",{"v":9.5,"d":"9.50"},21,32,{"v":6384,"d":"€ 6,384.00"}]
[null,"kapsalon",7.95,21,57,{"v":9516.15,"d":"€ 9,516.15"},null,"gebruik het werkblad bedrijfsresultaat"]
[null,"frisdranken",{"v":2.5,"d":"2.50"},21,75,{"v":3937.5,"d":"€ 3,937.50"}]
[null,"bier (1/2 liter)",{"v":4,"d":"4.00"},21,76,{"v":6384,"d":"€ 6,384.00"}]
[null,"wijn (flesje 250 ml)",{"v":5,"d":"5.00"},21,55,{"v":5775,"d":"€ 5,775.00"}]
[]
[{"$nulls":4},{"$f":"SUM(E25:E32)","v":507}]

{"sheet":"bedrijfsresultaat ","index":2,"n_rows":28,"n_cols":10,"rows_kept":28,"merged":[[13,3,13,6],[14,3,14,6],[16,3,16,6],[17,3,17,6],[19,3,19,9],[22,6,22,9],[23,6,23,8],[24,6,24,8],[25,6,25,8],[26,6,26,8],[27,6,27,8]]}
[]
[null,"Bedrijfsresultaat Restaria 2018"]
[]
[null,"omschrijving verkoop","omzet jan-feb","omzet mrt-apr","omzet mei-jun","omzet jul-aug","omzet sep-okt","omzet nov-dec","inkoopkosten","jaaromzet"]
[null,"frites met saus",{"v":16537.5,"d":"€ 16,537.50"},{"v":14962.5,"d":"€ 14,962.50"},{"v":21262.5,"d":"€ 21,262.50"},{"v":24255,"d":"€ 24,255.00"},{"v":22443.75,"d":"€ 22,443.75"},{"v":23310,"d":"€ 23,310.00"},{"$f":"H5*30%","v":{"v":6993,"d":"€ 6,993.00"}},{"$f":"SUM(C5:H5)","v":{"v":122771.25,"d":"€ 122,771.25"}}]
[null,"fish & chips",{"v":17456.25,"d":"€ 17,456.25"},{"v":18191.25,"d":"€ 18,191.25"},{"v":21131.25,"d":"€ 21,131.25"},{"v":24438.75,"d":"€ 24,438.75"},{"v":19845,"d":"€ 19,845.00"},{"v":20028.75,"d":"€ 20,028.75"},{"$f":"H6*30%","v":{"v":6008.625,"d":"€ 6,008.63"}},{"$f":"SUM(C6:H6)","v":{"v":121091.25,"d":"€ 121,091.25"}}]
[null,"frites stoofvlees",{"v":10972.5,"d":"€ 10,972.50"},{"v":9775.5,"d":"€ 9,775.50"},{"v":9177,"d":"€ 9,177.00"},{"v":8179.5,"d":"€ 8,179.50"},{"v":8578.5,"d":"€ 8,578.50"},{"v":11371.5,"d":"€ 11,371.50"},{"v":3411.45,"d":"€ 3,411.45"},{"v":58054.5,"d":"€ 58,054.50"}]
[null,"kapsalon",{"v":20868.75,"d":"€ 20,868.75"},{"v":20367.9,"d":"€ 20,367.90"},{"v":22204.35,"d":"€ 22,204.35"},{"v":21870.45,"d":"€ 21,870.45"},{"v":19032.300000000003,"d":"€ 19,032.30"},{"v":18698.4,"d":"€ 18,698.40"},{"v":5609.52,"d":"€ 5,609.52"},{"v":123042.15,"d":"€ 123,042.15"}]
[null,"frisdranken",{"v":13230,"d":"€ 13,230.00"},{"v":12285,"d":"€ 12,285.00"},{"v":13104,"d":"€ 13,104.00"},{"v":14994,"d":"€ 14,994.00"},{"v":13293,"d":"€ 13,293.00"},{"v":9854,"d":"€ 9,854.00"},{"v":2956.2,"d":"€ 2,956.20"},{"v":76760,"d":"€ 76,760.00"}]
[null,"bier",{"v":4620,"d":"€ 4,620.00"},{"v":3108,"d":"€ 3,108.00"},{"v":11760,"d":"€ 11,760.00"},{"v":18648,"d":"€ 18,648.00"},{"v":16716,"d":"€ 16,716.00"},{"v":13524,"d":"€ 13,524.00"},{"v":4057.2,"d":"€ 4,057.20"},{"v":68376,"d":"€ 68,376.00"}]
[null,"wijn",{"v":3675,"d":"€ 3,675.00"},{"v":3675,"d":"€ 3,675.00"},{"v":8085,"d":"€ 8,085.00"},{"v":12180,"d":"€ 12,180.00"},{"v":11025,"d":"€ 11,025.00"},{"v":9975,"d":"€ 9,975.00"},{"v":2992.5,"d":"€ 2,992.50"},{"v":48615,"d":"€ 48,615.00"}]
[null,"totale jaaromzet "]
[]
[null,"overige kosten op jaarbasis",null,"Bereken het aantal verkochte porties fis & chips"]
[null,"gas",{"v":7500,"d":"€ 7,500.00"}]
[null,"elektra",{"v":3500,"d":"€ 3,500.00"}]
[null,"huur pand incl. btw",{"v":36000,"d":"€ 36,000.00"},"Bereken de afzet van de frisdranken"]
[null,"verpakking (disposables)",{"v":50400,"d":"€ 50,400.00"}]
[null,"personeelskosten",{"v":225000,"d":"€ 225,000.00"}]
[{"$nulls":3},"Bereken hierboven (in de grijze vlakken) de omzet per maand van januari t/m december"]
[null,"prijslijst per verkochte eenheid"]
[null,"frites met saus",{"v":3.75,"d":"€ 3.75"}]
[null,"fish & chips",{"v":8.75,"d":"€ 8.75"},{"$nulls":3},"Bereken de gegevens:  "]
[null,"frites stoofvlees",{"v":9.5,"d":"€ 9.50"},{"$nulls":3},"Jaaromzet alle producten: "]
[null,"kapsalon",{"v":7.95,"d":"€ 7.95"},{"$nulls":3},"Inkoopkosten alle producten: "]
[null,"frisdranken",{"v":2.5,"d":"€ 2.50"},{"$nulls":3},"Brutowinst: "]
[null,"bier (1/2 liter)",{"v":4,"d":"€ 4.00"},{"$nulls":3},"Bedrijfskosten: "]
[null,"wijn (flesje 250 ml)",{"v":5,"d":"€ 5.00"},{"$nulls":3},"Nettowinst 2018: "]